UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QqbxD7mey7WMc5NSJeZKsS4KdUL5g1glT0pLnjaEyx8='
WHERE
key_id = '0b7008a7c85add957b026f9e68c4d9d1313316f1fa09e01a7aaf2fe1ec53b87e'
AND (
token = 'QqbxD7mey7WMc5NSJeZKsS4KdUL5g1glT0pLnjaEyx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)