UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzhbfqCgnG4KTn0+BmTAJB3VpooyWcAcx4hKGdYN26w='
WHERE
key_id = 'a31594779666c1022655cf899b98131e770d4529b088e6b61292f36b1cb8523f'
AND (
token = 'NzhbfqCgnG4KTn0+BmTAJB3VpooyWcAcx4hKGdYN26w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)