UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZ9Xghesgl0JEPae9L2Auj3j2xwZIzSbjsSvuT4/qL8='
WHERE
key_id = 'fbd8634689f4168440522ecdfbdc39b45f2bebbebdc4b5dd3e0e6cd752b01dec'
AND (
token = 'cZ9Xghesgl0JEPae9L2Auj3j2xwZIzSbjsSvuT4/qL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)