UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fX9DE4MlYYTD45ozWo+QmZjxNN8S0/UXR2iFjKxiQSM='
WHERE
key_id = '1bb8b2a3cc63b9a5bb3f6ffdf6c4c6719c65cdb7a62a4a3c27f411fbf046196b'
AND (
token = 'fX9DE4MlYYTD45ozWo+QmZjxNN8S0/UXR2iFjKxiQSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)