UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHNd5kAxErnMe5T2bJ2gNh8XsFHKCTFwhtZXkdYqyak='
WHERE
key_id = '3fba1eca1f6778ba369abb32e641d5a10c56534796611a4493d8b53270e3ba6c'
AND (
token = 'PHNd5kAxErnMe5T2bJ2gNh8XsFHKCTFwhtZXkdYqyak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)