UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lkfpx7N1jr60rIEQLC1vePQLfO4GA2A36Vxu9FuILw='
WHERE
key_id = 'fe4d3b9afb466b085a785ff0456738a8284d6ddc5de9f5ffd0fa27cc6aa64add'
AND (
token = '3lkfpx7N1jr60rIEQLC1vePQLfO4GA2A36Vxu9FuILw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)