UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2U49DFS2wJW0k8wCgTXpEYj7jqUJ/HLIxjLsHacLpiU='
WHERE
key_id = '270c7cda9b6499853fc6d66db4bc60182ee14c179210861618955d9e6594e2f6'
AND (
token = '2U49DFS2wJW0k8wCgTXpEYj7jqUJ/HLIxjLsHacLpiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)