UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cYE2tRAyfZwV/tqGf/cP78LkZX3H7asum1q3LMRHiM8='
WHERE
key_id = '4fad835bb40d6a44bb62675269d953d242f077fbe15f4f128df0709acaccf055'
AND (
token = 'cYE2tRAyfZwV/tqGf/cP78LkZX3H7asum1q3LMRHiM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)