UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tHqmM0JJigO6AKgIL9QREz1BVN9YeAIzERPAQAUiGM='
WHERE
key_id = '89400d6c9390cff1acc818b77faabfed882152f949b9d508a98b6a4116de8187'
AND (
token = '1tHqmM0JJigO6AKgIL9QREz1BVN9YeAIzERPAQAUiGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)