UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5G8DcQltPr9ZdJ1rOsnm2bkK8WsyMGn/SouxrhjTZ2Q='
WHERE
key_id = '4fac9e151b70864ec9659a8aad1651a4f0f908ad8d7068f2a2d2f66cbb4d356a'
AND (
token = '5G8DcQltPr9ZdJ1rOsnm2bkK8WsyMGn/SouxrhjTZ2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)