UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IUJLRGZD34dpgRyf79BUxl3/3Kjgq8/ht+3w4d/NvIE='
WHERE
key_id = 'ecdacb63fe298245ade931218f306ddf3e3e01a7dbf5c652f9765005f08b18a1'
AND (
token = 'IUJLRGZD34dpgRyf79BUxl3/3Kjgq8/ht+3w4d/NvIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)