UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BghPh93x70f2V85LjRvEmIefqUAcXNWiEG9KKSYXZvs='
WHERE
key_id = 'e29c65a4491832e2e325f24a9de18df2c0cabb4aa8f143080e29858c9b9fa2e7'
AND (
token = 'BghPh93x70f2V85LjRvEmIefqUAcXNWiEG9KKSYXZvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)