UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uNRqNimOyNkro295eYpwmQzoK5rMA36vbdPiRVVydFI='
WHERE
key_id = '74e8c9f3356eec4e193e3c83306816baf7ef7d1135a44aa2c4f0d3ccc3ba9331'
AND (
token = 'uNRqNimOyNkro295eYpwmQzoK5rMA36vbdPiRVVydFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)