UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LVP3uRiSiN8wFKe4M1K7pTmeZ6nCQcBPubXpW6nh+A='
WHERE
key_id = 'b296d33867f32108d308575810695bbd87fa12f45238574f2423857bbea1754e'
AND (
token = '6LVP3uRiSiN8wFKe4M1K7pTmeZ6nCQcBPubXpW6nh+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)