UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzBo2UFU+iDjoFcRSBYt0MTUeQopso/pK8i5hTmFaZs='
WHERE
key_id = '80e500c79381765bc745673cd985b31b1f9f3652fb1c4c24d40264afc1c1e949'
AND (
token = 'tzBo2UFU+iDjoFcRSBYt0MTUeQopso/pK8i5hTmFaZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)