UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0cpYe4ZqjL2H8LYG1hrvr0FfeED9gTPRRj0g1RjX0s='
WHERE
key_id = 'f0c468731d3b917a3524d4a89df0d60be0a486592737c12ea7b0c6c0ec652aa3'
AND (
token = 'W0cpYe4ZqjL2H8LYG1hrvr0FfeED9gTPRRj0g1RjX0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)