UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YY8qE7bG/wzSKVmn0fDca7vhzu2CthscJ55E3WKdrIg='
WHERE
key_id = 'dd7fca9d60c63d3c0aecfc5efcdabc31eb0a93c5ea8fe6fd8dc647abe0dc8127'
AND (
token = 'YY8qE7bG/wzSKVmn0fDca7vhzu2CthscJ55E3WKdrIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)