UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGJlXVgudM+n5BueWW8VbCdUF8KB8qEHdr0tCeC3YWU='
WHERE
key_id = '9b4c702a6490715187126d0671807a836662bd6717bf88d579bfba2aabeafa69'
AND (
token = 'XGJlXVgudM+n5BueWW8VbCdUF8KB8qEHdr0tCeC3YWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)