UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UCdFYie4EnVPU1hTRphIUwMxG28Mk+dnPo/1Mu/u+bs='
WHERE
key_id = '4e4cf1ace67f245f1cc5b69dc240cc1717239f177fb8ec19a106a2362d9ff41c'
AND (
token = 'UCdFYie4EnVPU1hTRphIUwMxG28Mk+dnPo/1Mu/u+bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)