UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wtDakgTrw/5YlQQjvTsU1sPR65vAwVX1FBADiLpc8Fo='
WHERE
key_id = '31abdbd99fc8157d3b8295f4394f22699d492d7e6847b56574a159046daa7b20'
AND (
token = 'wtDakgTrw/5YlQQjvTsU1sPR65vAwVX1FBADiLpc8Fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)