UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFYmco/a2Y+xfiCGVE0yPb7BdXz8mv7J+VmH+de7vOc='
WHERE
key_id = 'd6c5c2811dcb40b01df8e595515a8feb614bbf164a7225f574bc64241971fbd7'
AND (
token = 'gFYmco/a2Y+xfiCGVE0yPb7BdXz8mv7J+VmH+de7vOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)