UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnbSkPo89kzBcgVp1ywU3aTfwknRMXwkkvrXUkBx6I8='
WHERE
key_id = '1493a35278100dc2c72cbef4eedd7dce14e80c8f810a1e88233409e305785022'
AND (
token = 'vnbSkPo89kzBcgVp1ywU3aTfwknRMXwkkvrXUkBx6I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)