UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0YIEwJmKNjjQU4OW6U8LdXugbhaO6YXZ56K5eUF3Vo='
WHERE
key_id = '502e66b9a69079d7da0a7c401408fb9840cb3e450187cf101fbf59d3b8f14dfb'
AND (
token = 'R0YIEwJmKNjjQU4OW6U8LdXugbhaO6YXZ56K5eUF3Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)