UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'T+NqT6fuEcGAHNgJcmjskCQd7MMpoMPCjrQmUyMdifk=' 
WHERE 
  key_id = '7caa6caed74dc93b24fcb6ef066635c46912c18a529113b2b8266c6efbc193ac' 
  AND (
    token = 'T+NqT6fuEcGAHNgJcmjskCQd7MMpoMPCjrQmUyMdifk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032