UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QP26hG5QKbWQJBOz/zF3zUp4QAQOUt/kRjzenJeGxMA=' 
WHERE 
  key_id = '2d39ecff232c7a86f31be58f5c123a7eab0ab6b58c8a1edaa7063669c49ae22c' 
  AND (
    token = 'QP26hG5QKbWQJBOz/zF3zUp4QAQOUt/kRjzenJeGxMA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057