UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tfxHhveC2EJUoev60SCRZcYPkDQdHkkGjNpHSMq9HM4='
WHERE
key_id = '47779810b9d7be36c44dfb32c5e2b2d6a493bb733929c2d4ef14f004972d5d46'
AND (
token = 'tfxHhveC2EJUoev60SCRZcYPkDQdHkkGjNpHSMq9HM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)