UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlTdVG0KvMrHpYgd4HH9E7F+TAMdavYxyIOEqbNXTBU='
WHERE
key_id = '83fa83663dcd4454b7f35574a41574956b09e3a49759c30ae8b1b9bb3757f617'
AND (
token = 'zlTdVG0KvMrHpYgd4HH9E7F+TAMdavYxyIOEqbNXTBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)