UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1q9tpToEQzn9gHFkwMIlcCm9AvQz3Dbsur6aQKgTSFk='
WHERE
key_id = 'a600fba43d09dad5548c9bebaefe8eac30b35381d7329ec7b56b673d068f571b'
AND (
token = '1q9tpToEQzn9gHFkwMIlcCm9AvQz3Dbsur6aQKgTSFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)