UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46Z4UeWW6R4ZdPO3nZGLGuLVl2EK8M1CREJHsLdqiKw='
WHERE
key_id = '03a24a1c7f8d684455f50dc1415305de97dbb7aeb57c655fd5634aaf750f00df'
AND (
token = '46Z4UeWW6R4ZdPO3nZGLGuLVl2EK8M1CREJHsLdqiKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)