UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IfxQcKB1y2KOtUZwnYHEqGK0urzaRwLkwHJbFZNCTUg='
WHERE
key_id = 'c07a5db10d5ad27be01ca3e32c7d2f5671ef1f11176c2d23925e6acc25bf10ae'
AND (
token = 'IfxQcKB1y2KOtUZwnYHEqGK0urzaRwLkwHJbFZNCTUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)