UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/T/vEm2auxvLS1qvvoIjZUgvDMCUiFb7vJsY/2MhvSc='
WHERE
key_id = '49fe9d39e5f3493635fb9cffa30087634bfca5241e2352a21fe091d0fc8b5662'
AND (
token = '/T/vEm2auxvLS1qvvoIjZUgvDMCUiFb7vJsY/2MhvSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)