UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4RzMHNxiT0qQUpn0m9FkV1AbAEOQ5y5MBiyHje8xww='
WHERE
key_id = '49f6a17aa35c0763ac5780001ac90a5aa5eab631db1c979ced2977a39aada869'
AND (
token = 'W4RzMHNxiT0qQUpn0m9FkV1AbAEOQ5y5MBiyHje8xww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)