UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIpWxViYCOs9yJD8/dtXroYSw3SzxY+X9G4LqNWRWdo='
WHERE
key_id = '3031f166a89a121397d3582dd026a4bdc03a7d1e546c0aa2d339eed3dc3ff5bd'
AND (
token = 'XIpWxViYCOs9yJD8/dtXroYSw3SzxY+X9G4LqNWRWdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)