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