UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+F8EtPLGov59xe+znbNPCYWk/JUDpMtCmJypOhY7Zs='
WHERE
key_id = 'b4beb01ee43d22cc229f110ea4c54ab6c6d03664f3727e84153add305312be49'
AND (
token = 'x+F8EtPLGov59xe+znbNPCYWk/JUDpMtCmJypOhY7Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)