UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVGB02wRsVxLpM1qJHQR94a4PBtRzcOkrmAcD4m+M68='
WHERE
key_id = '936be3aca5bbcaf0e32a89a6efc80ec036b9182712f525d3605c9a17b87745cf'
AND (
token = 'kVGB02wRsVxLpM1qJHQR94a4PBtRzcOkrmAcD4m+M68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)