UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CmAUm8sme7DAVN5/d/Aw0vGnBSXXCck5xSKgEcZNQpI=' 
WHERE 
  key_id = '04764f5ea0139b44ee38c6d05ad2af05faff3c0081cbb6c84918be5b5ff0786e' 
  AND (
    token = 'CmAUm8sme7DAVN5/d/Aw0vGnBSXXCck5xSKgEcZNQpI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040